class CreateMembers < ActiveRecord::Migration		
  def self.up		
    create_table :members do |t|		
	t.column	:id,	:integer
	t.column	:nickname,	:string
	t.column	:truename,	:string
	t.column	:company,	:string
	t.column	:address,	:string
	t.column	:sex,	:string
	t.column	:age,	:integer
	t.column	:race,	:string
	t.column	:mobile,	:string
	t.column	:email,	:string
	t.column	:joindate,	:DATE 
	t.column	:lastparty,	:integer
	t.column	:degree,	:integer,:default => 4
	t.column	:score,	:integer,:default => 0
	t.column	:password,	:string
	t.column	:last_acc_date,	:datetime
	t.timestamps		
    end		
  end		
		
  def self.down		
    drop_table :members		
  end		
end